-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- Host: mysql5.cws.oregonstate.edu
-- Generation Time: May 22, 2019 at 12:40 PM
-- Server version: 5.1.63
-- PHP Version: 5.3.3-7+squeeze9

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `cw_61046`
--

-- --------------------------------------------------------

--
-- Table structure for table `CodesFileArchive`
--

CREATE TABLE IF NOT EXISTS `CodesFileArchive` (
  `FileCode` text NOT NULL,
  `FileDesc` text NOT NULL,
  `FileImport` text NOT NULL,
  `FileTable` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `CodesFileArchive`
--

INSERT INTO `CodesFileArchive` (`FileCode`, `FileDesc`, `FileImport`, `FileTable`) VALUES
('_A', 'Daily Weather  Measurements', '79', 'Weather'),
('_B', 'Daily Pond  Measurements', '70', 'PondData'),
('_C', 'Miscellaneous Observations Including Fish Health', '4', 'FishObsv'),
('_D', 'Intensive Sampling Measurements', '70', 'WatQual2'),
('_E', 'Diel Measurements', '74', 'WatQual3Day'),
('_F', 'Fish/Shrimp Stocking, Sampling, and Harvesting', '80', 'FishData'),
('_G', 'Plankton and Benthos', '33', 'PlankBen'),
('_H', 'Water Quality Measurements', '27', 'WatQual1'),
('_I', 'Pond Soil Characteristics', '41', 'PondSoil'),
('_J', 'Pond Morphometrics', '12', 'PondSpec'),
('_K', 'Analysis of Nutrients and Lime', '57', 'FertAnal'),
('_L', 'Nutrient and Lime Inputs', '71', 'FertApp'),
('_M', 'Analysis of Compost', '0', '???'),
('_R', 'Cumulative Readings, Solar, Wind', '14', 'WeathCum'),
('_Z', 'Mortalities', '12', 'FishMort'),
('K_071AOT', 'Other Dissolved Oxygen and Water Temperature', '0', 'solo file'),
('K_071APH', 'pH Readings', '0', 'solo file'),
('K_071ARA', 'Rain', '0', 'solo file'),
('New1', 'Diurnal weather measurements', '1', 'WeathDay'),
('New2', 'Diurnal water quality', '1', 'WatQual1Day'),
('PT', 'Pond Information: Treatments, Area, Etc.', '54', 'PondTrt');
